Abstract: In recent years, with the rapid development of the communication industry, more and more broadband accessed. Customers on the bandwidth and broadband quality put forward higher requirement, how to reduce the operation and maintenance costs, and improve network quality are the biggest problem for corporations. So corporations must have a whole understanding for the communication line state. As the above problems, this paper according to the enterprise to communication line state statistics demand, through the application of data warehouse and OLAP technology for the original communication lines state statistics the multidimensional data analysis, makes a practical scheme for line state statistical. This plan can offer reference in telecommunications companies in line state statistics.

Key words: broadband, data warehouse, OLAP